Skip to main content
Version: 9.2

Multiseries Combo Chart

Use a Multiseries Combo Chart to display multiple metrics over multiple dimensions. It combines a Multiseries Chart with any number of layers of any type of X/Y Chart (Bar Chart, Line Chart, and Symbol Chart). You can use a Multiseries Combo Chart to create a visualization with one category, one series, and two or more values.

ms-combo-chart-82

Create a Multiseries Combo Chart​

To create a Multiseries Combo Chart, drag a data field from the Data panel onto the corresponding shelf or the canvas. The Multiseries Combo Chart requires a category, a series, and at least two values in the shelves.

The following image shows how to use a Multiseries Combo Chart to provide insights about which customers are purchasing high-margin products. The chart displays a bar chart of each product (productName) on the x-axis and the quantity of items sold (quantityOrdered) on the y-axis. The bar chart is stacked to display the customers of each product (customerName) and the number of units purchased (quantityOrdered).

For analyzing product sales, the chart also examines the profit margin of each product. The chart displays the wholesale cost of each product (buyPrice) as an upward-facing triangle and the price the customer paid (priceEach) as a downward-facing triangle. The distance between the two triangles provides a visual indicator of the price and profitability of the product. Using this chart, you can see which products have high (or low) margins and identify the customers who purchase them.

ms-combo-chart-example-82

Style the Multiseries Combo Chart​

General​

The General section is available for all chart types, and the options vary depending on the chart selected.

Note: Use the Table Calculations option to add calculations to your chart. For more information, see Table Calculations.

Styles​

The Styles section enables you to control various visual elements of the charts, such as colors, labels, and more. It is available for most chart types, and the options vary depending on the chart selected. This chart contains the following style options:

  • Theme - Set a theme that applies to the Series and the Combo values. By default, the Match colors across charts option is enabled for colors set by category. You can apply custom colors for each chart category by selecting the Color by Value icon in the Theme section. You can then use the Color by value dialog to assign custom colors for each category, or select one color for all values.

    Note: To make the Color by Value icon available to customize category colors, the Category field in a chart must be set to a date or a text column.

  • Multiseries Type - Select whether to display the chart as Bar, Line, or Symbol.

  • X-axis

    • Axis Title - Select whether to display the axis title.
    • Value Labels - Select whether to display the value labels.
    • Values Rotation - If values are enabled, decide how you want them to be displayed.
    • Typeface - Select the typeface of the labels.
    • Weight - Select the font weight of the labels.
    • Size - Select the font size of the labels.
    • Font Color - Select the font color of the labels.

  • Y-axis

    • Axis Title - Select whether to display the axis title.
    • Value Labels - Select whether to display the value labels.
    • Values Rotation - If values are enabled, decide how you want them to be displayed.
    • Typeface - Select the typeface of the labels.
    • Weight - Select the font weight of the labels.
    • Size - Select the font size of the labels.
    • Font Color - Select the font color of the labels.

  • Bar Width - Manually set the width of the bars.

  • Type - Select a side-by-side or stacked display for the bars.

  • Symbol - Select a different symbol shape when multiseries type is set to symbol.

  • Fill - Set the symbol to Hollow or Filled when multiseries type is set to symbol.

  • Data Field - This section takes the name of the data field in the Values and Other Values shelves, starting with the second value. Each section corresponds to one of the selected Value fields and allows the respective chart for that field to be configured.

    combo

Sorting​

Multiseries Combo Charts can be sorted by their selected category column, or either of the value columns used in them. Choose the column to sort from the dropdown list and select the sorting direction (ascending or descending) from the icons under the dropdown.

For more information, see Sorting.

Layers​

Add a trend line or reference line to your chart to allow users to visually compare the data against a set trend or reference value.

Format​

The Conditional Formatting option is available in Multiseries Combo Charts.

Filters​

You can also add filters to your data by expanding the Filters section in the configuration panel or by selecting Filters in the toolbar above the canvas.

Filters that are created in the Chart Builder are hidden from end users. You cannot edit these filters or interact with them in view mode.

Multiseries Combo Charts support Filter By, which applies a filter over the chart’s data when users select a data point.